SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and (type = 'R' or type ='O')
AND list_price BETWEEN '1000000' AND '99999999'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 10
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Discreetly tucked away to ensure privacy and leisure, this Mascoma Lake estate has it all. A rare opportunity on Mascoma Lake, this property has a grandfathered boathouse to store all your toys. Leading you out of the boathouse is your own personal dock. When you aren’t on your boat exploring the lake, sit on the oversized deck and soak in the views. An ideal location for hosting all of your get-togethers. The 180 degree views from every room allows pure natural light to permeate through this home. With the ability to connect to the town sewer system, this 3 bedroom home has the opportunity to be a 5+ bedroom home. Should you seek an in-law suite/studio, there is a bonus suite on the upper level that is plumbed for a kitchen. The basement contains finished space with a partial kitchen, allowing convenience for your hosting needs. This is luxury living.
Description:Nestled on one of the most serene roads in Lyme, this stunning 1988 colonial reproduction farmhouse seamlessly blends with the picturesque countryside. Lovingly maintained and thoughtfully upgraded over the years, the property features a notable 2009 addition by Vermont Vernacular, including a spacious dining room, mudroom, laundry room, garage, and an inviting in-law suite above the garage. The home exudes warmth with its hickory flooors, abundant natural light, and cozy, welcoming spaces. The heart of the house is the expansive, functional kitchen, where you can gather around the pellet stove for a warm, comforting ambiance. The dining room, with its large windows, offers stunning views of the gardens and the rolling hills beyond, creating a perfect setting for meals with a view. Trout Brook, meandering below the property, provides a soothing soundtrack year-round, enhancing the tranquility of the setting. The large, heated garage, with a versatile guest suite above, is perfect for guests or an artist’s studio. The architectural details, including archways inspired by those on the carriage sheds at the historic Lyme Congregational Church, add to the home's unique character. Set on 21 acres and conveniently close to the Dartmouth Skiway, Post Pond, and an extensive network of hiking trails, this property offers an exceptional opportunity to embrace the great outdoors right at your doorstep. Open House Friday 9/6/24 5-7pm Cocktail Hour and Saturday 10-12n Mimosa Bar
Description:HERMIT HILL FARM- One of the most rare and spectacular estates in the region, the property sits on 700 pristine acres minutes from Lyme Village and a very short trip to Hanover, home of Dartmouth College. The farm has been in the same family for generations. The area around the main house is idyllic, with rolling fields, a large swimming pond with beach, apple orchard, gorgeous landscaped grounds, quaint barns, and western views from several areas. The farm operated as an equestrian estate for many years and has a 11-stall central barn with solar array, large indoor riding arena, outdoor arena, and fenced paddocks with run-in sheds. There are miles of trails to explore the property, perfect for hikes, walks with the dogs, snowshoeing or x-country skiing, ATV riding, and mountain biking. The main hill on the south side of the house even once had its own ski-tow, later replaced by snowmobiles. The main house is spacious and sophisticated and has been expanded over the years to include a private bedroom wing and large great room for family gatherings. There are 5 bedrooms and 5 baths in total. The historic details of the interiors are beautiful– warm woodwork and original paneling with modern sophistication such as radiant flooring and top of the line appliances. The farm is in conservation but allows for potential subdivision and there is significant timber value. This farm is a true New England gem and needs to be experienced. Note: some interior photos were virtually staged.